Dashboard 01 - Creating Cards and Slicer 15
In this step, we will create cards in this first dashboard.
Step 1: Create District Name Card
In Power BI Desktop, click on the page, RaleighPoliceIncidents
Click inside the pane
Visualizations
Click the Card icon
Fields
Select the following:
A_KeyMeasures -> .Measure_District
Visualizations
Under Fields tab, click on the down arrow -> Rename for this visual and rename the card to District Name
Under Format -> General: X Position = 983 , Y Position = 108 , Width = 417 , Height = 36
Under Format -> Data Label -> Color = 094780 , Text Size = 20 pt , Font = DIN (default)
Under Format -> Category -> Set it to OFF
Under Format -> Title -> Set it to OFF
Under Format -> Background -> Set it to ON , Color = CCCCCC
Step 2: Create Violent Crime Rate Card
Click inside the pane
Visualizations
Click the Card icon
Fields
Select the following:
A_KeyMeasures -> .Transparent_Violent_CrimeRate%
Visualizations
Under Fields tab, click on the down arrow -> Rename for this visual and rename the card to Violent Crime Rate
Under Format -> General: X Position = 1 , Y Position = 176, Width = 225 , Height = 160
Under Format -> Data Label -> Color = 000000 , Text Size = 28 pt , Font = DIN (default)
Under Format -> Category -> Set it to ON -> Color = 000000 , Text Size = 15 pt , Font = Segoe UI
Under Format -> Title -> Set it to OFF
Under Format -> Background -> Set it to ON , Color = E6E6E6Under Format -> Border -> Set it to ON , Color = 666666
Step 3: Create Major Crime Rate Card
Click inside the pane
Visualizations
Click the Card icon
Fields
Select the following:
A_KeyMeasures -> .Transparent_Major_CrimeRate%
Visualizations
Under Fields tab, click on the down arrow -> Rename for this visual and rename the card to Major Crime Rate
Under Format -> General: X Position = 1 , Y Position = 587, Width = 225 , Height = 160
Under Format -> Data Label -> Color = 000000 , Text Size = 28 pt , Font = DIN (default)
Under Format -> Category -> Set it to ON -> Color = 000000 , Text Size = 15 pt , Font = Segoe UI
Under Format -> Title -> Set it to OFF
Under Format -> Background -> Set it to ON , Color = E6E6E6Under Format -> Border -> Set it to ON , Color = 666666
Alternatively, copy and paste the Violent Crime Rate Card, rename it and format the position. As follows:
Under Fields tab, click on the down arrow -> Rename for this visual and rename the card to Major Crime Rate
Under Format -> General: X Position = 1 , Y Position = 587, Width = 225 , Height = 160Step 4: Create Year Over Year (YOY) Violent Crime Rate Card
To get started, Copy and Paste Violent Crime Rate Card and configure it as follows:
Visualizations
Click the Card icon
Fields
Select the following:
A_KeyMeasures -> .Transparent_Violent_Crimes_YOY%
Visualizations
Under Fields tab, click on the down arrow -> Rename for this visual and rename the card to YOY Violent Crime Rate
Under Format -> General: X Position = 1 , Y Position = 368 , Width = 225 , Height = 160
Under Format -> Data Label -> click fx -> Format by = Color Scale, Based on Field = .YOY_Violent_CrimeRate% , Minimum = 5B8F22 with a value of 0.00001 , Maximum = FF0000 with a value of 0 , Text Size = 28 pt , Font = DIN (default)
Under Format -> Category -> Set it to ON -> Color = 000000 , Text Size = 15 pt , Font = Segoe UI
Under Format -> Title -> Set it to OFF
Under Format -> Background -> Set it to ON , Color = E6E6E6Under Format -> Border -> Set it to ON , Color = 666666
Step 5: Create Year Over Year (YOY) Major Crime Rate Card
To get started, Copy and Paste the Year Over Year (YOY) Violent Crime Rate Card and configure it as follows:
Visualizations
Click the Card icon
Fields
Select the following:
A_KeyMeasures -> .Transparent_Major_Crimes_YOY%
Visualizations
Under Fields tab, click on the down arrow -> Rename for this visual and rename the card to YOY Major Crime Rate
Under Format -> General: X Position = 1 , Y Position = 791 , Width = 225 , Height = 160
Under Format -> Data Label -> click fx
-> Format by = Color Scale, Based on Field =
.YOY_Major_CrimeRate% , Minimum = 5B8F22 with a value of 0.00001 ,
Maximum = FF0000 with a value of 0 , Text Size = 28 pt , Font = DIN
(default)
Under Format -> Category -> Set it to ON -> Color = 000000 , Text Size = 15 pt , Font = Segoe UI
Under Format -> Title -> Set it to OFF
Under Format -> Background -> Set it to ON , Color = E6E6E6Under Format -> Border -> Set it to ON , Color = 666666
Step 6: Create Year Slicer
Visualizations
Click the Slicer icon
Fields
Select the following:
Raleigh_Police_Incidents_NIBRS -> Reported_Date -> Date Hierarchy -> Year
Visualizations
Under Fields tab, click on the down arrow -> Rename for this visual and rename the card to YOY Major Crime Rate
Under Format -> General: X Position = 983 , Y Position = 0 , Width = 250 , Height = 108
Under Format -> Numeric Inputs -> Font Color = 000000, Text Size = 13 pt , Font = Segoe UI
Under Format -> Slider -> Set it to ON -> Color = 094780
Under Format -> Title -> Set it to ON , Title Text = Years, Font Color = 094780 , Background Color = E6E6E6 , Alignment = Center , Text Size = 17 pt , Font Family = DIN (Default)
Under Format -> Border -> Set it to ON , Color = 666666